Model Table ASSET HEALTH LEVEL

Attributes

Attribute Description (where applicable)
Asset GroupRepresents the Asset Group (Equipment/Linea Asset/Etc.)
ColorRepresents the Color Code for Health Level
Dim_Asset_TypeDimension ID for Asset Type
Health Level Count
IDKey for Health Level setup value - Combination of Asset Group + Asset Type + Color Code
IntervalMaxRepresents the Max interval value for the health level for the Asset Type
LevelRepresents the description of the Color Code
Mvt_Created_Dt
Obj TypeRepresents the Asset Type

USED BY MODEL(S)

Model Name
Maintenance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ASSET HEALTH LEVELFACT_ASSET_HEALTH_LEVEL_TMFACT_ASSET_HEALTH_LEVEL_BIFACT_ASSET_HEALTH_LEVELOn Line